MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Home / Family Medical Records (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 139KB | 1,242 lines

elecom.fax! s1126 1 zer.z-netz.telecom.gateway! s95 1 zer.z-netz.telecom.lan! s24 1 zer.z-netz.telecom.modem! s62 1 zer.z-netz.telecom.satellit! s31 1 zer.z-netz.umweltschutz! s20 1 zer.z-netz.verbrauchertips! s163 1 zer.z-netz.verkehr! s112 1 zer.z-netz.wissenschaft.astronomie! s6 1 zer.z-netz.wissenschaft.biologie! s4 1 z-netz.bildung.allgemein! s15 0 z-netz.bildung.schule! s178 0 z-netz.bildung.uni! s68 0 z-netz.datenschutz.allgemein! s125 0 z-netz.datenschutz.spionage! s27 0 HBAM2016AUG95 Pro 3.0 z-netz.forum.diskussion.allgemein! s19 0 z-netz.forum.diskussion.philosophie! s24 0 z-netz.forum.diskussion.politik! s2770 0 z-netz.forum.news! s95 0 z-netz.forum.religion! s718 0 z-netz.forum.soziales! s8 0 z-netz.forum.umweltschutz! s102 0 z-netz.forum.verbrauchertip! s67 0 z-netz.forum.verkehr! s108 0 z-netz.forum.versicherung! s32 0 z-netz.freizeit.allgemein! s70 0 z-netz.freizeit.brettspiele! s88 0 z-netz.freizeit.consolen! s436 0 z-netz.freizei freizeit.zeitschriften! s23 0 z-netz.fundgrube.biete! s95 1 z-netz.fundgrube.biete.allgemein! s2043 0 z-netz.fundgrube.biete.elektronik! s2733 0 z-netz.fundgrube.gratis! s206 0 z-netz.fundgrube.job-boerse! s81 0 z-netz.fundgrube.suche.allgemein! s760 0 z-netz.fundgrube.suche.elektronik! s829 0 z-netz.fundgrube.wohnraum! s86 0 z-netz.gesundheit.aids! s4 0 z-netz.gesundheit.allgemein! s104 0 z-netz.gesundheit.drogen! s443 0 z-netz.gesundheit.krankheiten! s36 0 z-netz.gesundheit.pharmaka! s18 0 z-netz.gesundheit.tips! s73 0 z-netz.koordination.di HBAM3016AUG95@ centerB hospitalF redwoodB redwood hospitalF redwood medical centerB accidentF brokeF castG doctorG emergencyF emergency medical treatment broke motorbike accidF examA examineG medicalF motorbikeF physicalC rashB removeH remove castH routineA routine examA routine physical examC takeG doctor examine castG treatmentB treatment rashB bre'kenF bre'ken e'e'kB exe'mA exe'mA hee'rtD hee'rt pe'lpite'tie'nsD pe'ise'nB pe'ise'n e'e'k re'shB pe'lpite'tie'nsD physice'lC physice'l exe'mC re'shB CLAIM SUBMITTED : CONDITION DATE CREATED DATE MODIFIED DATE OF INVOICE DATE OF ONSET . DIAGNOSIS FACILITY FAMILY MEMBER INS CLAIM NUM INS GROUP NUM INS PAID AMOUNT INS POLICY HLDR INS POLICY NUM INSTRUCTIONS INSURER INVOICE ID LAST LAYOUT MEDICAL NEED MEDICAL PROVIDER PATIENT AMOUNT PHONE NUMBER RECORD ID REFERRED BY RESOLUTION STATE STREET TREATMENT TREATMENT AMNT ZIP CODE A Record IDB DateB FacilityB StreetB CityB StateB Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/20/95 Description This database keeps track of all medical events in your family. Use this database to record pertinent information, such as diagnosis and instructions, to keep a medical history for each family member, and to track insurance billing and payment. How to use this solution For each medical event, record the family member, condition, and date. Then use the tabs to enter and view information for the medical provider, treatment, and insurance information. To see a medical history fo r each person in the family, run the Medical History report. How to customize this solution Create a separate file to hold information on each of the family's regular medical providers and another one for insurance carriers. Then use lookups to quickly and accurately enter information in the Medical Provider and Insurance areas. By using lookups rather than relations, each record will retain the historical data, even if the doctor moves or the insurance information changes. X1The state field should only contain 2 characters. ) = 2 ) ZIP CodeB Phone NumberB Date CreatedB Date ModifiedB Medical ProviderB Family MemberB Date of OnsetB Medical NeedB InstructionsB ResolutionB 7A TreatmentB Invoice IDB Claim SubmittedB Ins Claim NumB Treatment AmntB Ins Paid AmountB Patient AmountB InsurerB Ins Group NumB Ins Policy NumB Ins Policy HldrB CA DiagnosisB Referred ByB Date of InvoiceB FA ConditionB InfoB Last LayoutB "AhA%Form View - Medical Need and Provider A List View Medical History Information Report Menu @PA#Form View - Treatment and Diagnosis @HA!Form View - Insurance and Billing A%Form View - Medical Need and ProviderB Yesfter Noarter Yesfter Noarter Yesfter Noarter A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Medical Need Date of Onset Medical Provider Referred By Phone ZIP Code Address Treatment Facility j Condition Family Member Medical Need & Provider Insurance & Billing Treatment & DiagnosisOwn Button Your Own Button Record Delete Record Record Reports View As View As Close Medical Need Date of Onset Medical Provider Referred By Phone ZIP Code Address Treatment Facility j Condition Family Member Medical Need & Provider Insurance & Billing Treatment & Diagnosis o/Enter data for Medical Provider & Family Member Medical HistoryB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Q ConditionR Medical ProviderS Family MemberT DateU Your Own ButtonV Your Own ButtonW RecordX Delete RecordY RecordZ Reports[ View As List\ View As Form] Close^ Info_2Click to see more information for a Medical record InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Resolution Instructions h Diagnosis i Treatment Medical Provider Onset Family Member n Condition Medical Need Page ## Medical History Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO5Information about the Family Medical Records solutionP Info for this Solution e Family Medical Records solutionP Info for this Solution Your Own ReportB Your Own ReportC Your Own ReportD Medical HistoryE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report A#Form View - Treatment and DiagnosisB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF A!Form View - Insurance and BillingB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Resolution Instructions to Family Member d Diagnosis e Treatment g Condition Family Member Medical Need & Provider Insurance & Billing Treatment & Diagnosis l$Enter data for Treatment & Diagnosis Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Patient Amount: Paid by Insurance: Total Amount: Invoice ID Invoice Date Billing Claim Number Policy Holder Group Number Policy Number Insurer h Insurance j Condition Family Member Medical Need & Providerur Own Button Your Own Button Record Delete Record Record Reports View As View As Close Patient Amount: Paid by Insurance: Total Amount: Invoice ID Invoice Date Billing Claim Number Policy Holder Group Number Policy Number Insurer h Insurance j Condition Family Member Medical Need & Provider Insurance & Billing Treatment & Diagnosis o"Enter data for Insurance & Billing 3/1/94O 3343 Lark Ln.P Mountain ViewQ 94040U 415-555-7801X 10/19/95Y 10/19/95_ Dr. Pesnerj Routine eye exam.y 31684z Claim Submitted{ 438527| Living Well 33683 20/20 Vision. Pediatrician 3/1/94 Eye Exam 4/2/94G Redwood Medical CenterO 542A Sansome St.P Redwood CityQ 94062U 415-555-8714X 10/19/95Y 10/19/95_ Dr. Howardj Sallyn 3/28/94q Treatment of rash.t$Apply prescribed lotion twice daily.u Cleared up in one week.y 2283z Claim Submitted{ 438562| Living Well 33683 4/2/94 Poison Oak Rash 4/5/94O 454 BroadwayP Redwood CityQ 94062U 415-555-9272X 10/19/95Y 10/19/95_ Dr. Lonniganj Routine Physical Examy 1396z Claim Submitted{ 438785| Living Well 33683 Good bill of health. 4/5/94 Physical Exam 6/18/94G Redwood Medical CenterO 539A Sansome St.P Redwood CityQ 94062U 415-555-1011X 10/19/95Y 10/19/95_ Dr. Martinezj 6/17/94begin daily exercise program. Your Own ButtonB ReportsC View As ListD View As FormE CloseF Information List View Report Menu Sort by Date Sort by Patient Sort by Medical Provider Sort by Condition or Illness Sort for Medical History Medical History Open Script Dial Phone Sort by Date Sort by Patient Medical History Sort by Medical Provider Yesfter Noarter Helvetica Geneva Times Times New Roman Arial MS Sans Serif Arial MT Condensed Light Sort by Condition or Illness Sort for Medical History Open Script Dial Phone Cancel Specify Field Use Dialing Preferences Phone Number Field Value Number You did not enter any find criteria; all records will be displayed. A List View Information Report Menu A Find Copy )=400 Cancel ER_DRAWH RIZRULER You did not enter any find criteria; all records will be displayed.C+ ) = 0 wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw (LIST LISTA Claim Submitted VDEFA( (LIST VDEFA( Insurance Claim Submitted ListB Condition or Illness List wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFG CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7 !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww medicalB redwoodB redwood hospitalF redwood medical centerB 3343A broadwayC 539aD sansome 542aB sansome alamedaF alamedaF broadwayC medicalF motorbikeF physicalC rashB removeH remove castH routineA routine examA routine physical examC takeG doctor examine castG treatmentB treatment rashB bre'kenF bre'ken e'e'kB exe'mA exe'mA hee'rtD hee'rt pe'lpite'tie'nsD pe'ise'nB pe'ise'n e'e'k re'shB pe'lpite'tie'nsD physice'lC physice'l exe'mC re'shB 333333 wwwwww UUUUUU DDDDDD """""" """"$ medical@ lark@ ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 Eite'tie'ns hee'rt pe'lpite'tie'ns bre'ken Pro 2.0 - 2.1F! Pro 3.0 Franz App t@Cut down on salt and caffeine, and begin daily exercise program.w Electrocardiogram, Chest X-Raysy 51681z Claim Submitted{ 438785| 214.4~ Good Hands Health Care 13065 446825 Knight Sheet Metal Corp. Borderline high blood pressure. 6/18/94 Heart Palpitations 7/14/94G Redwood Medical CenterO 539A Sansome St.P Redwood CityQ 94062U 415-555-1011X 10/19/95Y 10/19/95_ Dr. Martinezj 6/17/94t4Continue modified diet and regular exercise program.y 52003z Claim Submitted{ 439684| Good Hands Health Care 13065 446825 Knight Sheet Metal Corp. Blood pressure improved. 7/14/94 Heart Palpitations 8/25/94G Redwood HospitalO 548 The AlamedaP Redwood CityQ 94062U 415-555-6717X 10/19/95Y 10/19/95_ Dr. Singhj 8/25/94qAEmergency medical treatment. Tom broke leg in motorbike accident.t0Stay off leg as much as possible. Keep cast dry.w Leg X-Rays. Set leg in cast.y 100106z Claim Submitted{ 442680| 948.63} 853.77~ 94.86 Information List View Report Menu Sort by Date Sort by Patient Sort by Medical Provider Sort by Condition or Illness Sort for Medical History Medical History Open Script Dial Phone Sort by Date Sort by Patient Medical History Sort by Medical Provider Living Well 33683 C*Multiple fractures in both thigh and shin. 9/1/94 Broken Leg 9/11/94G Redwood HospitalO 548 The AlamedaP Redwood CityQ 94062U 415-555-6717X 10/19/95Y 10/19/95_ Dr. Singhj 8/25/94q#Take Tom to doctor to examine cast.t0Stay off leg as much as possible. Keep cast dry.w Leg X-Rays.y 101048z Claim Submitted{ 445740| Living Well 33683 Bones are healing well. 9/14/94 Broken Leg 10/1/94G Redwood HospitalO 548 The AlamedaP Redwood CityQ 94062U 415-555-6717X 10/19/95Y 10/19/95_ Dr. Singhj 8/25/94q Remove cast.t@Light exercise for next two weeks. No heavy exercise until then.w Leg X-Rays. Removed Cast.y 102596z Claim Submitted{ 447421| Living Well 33683 Bones have set well. 10/1/94 Broken Leg larkA sansomeB accidentF brokeF castG doctorG emergencyF emergency medical treatment broke motorbike accidF examA examineG medicalF motorbikeF physicalC rashB removeH remove castH routineA routine examA routine physical examC takeG doctor examine castG treatmentB treatment rashB bre'kenF bre'ken e'e'kB exe'mA exe'mA hee'rtD hee'rt pe'lpite'tie'nsD pe'ise'nB pe'ise'n e'e'k re'shB pe'lpite'tie'nsD physice'lC physice'l exe'mC re'shB )=400 Cancel ER_DRAWH RIZRULER You did not enter any find criteria; all records will be displayed.C+ ) = 0 Cancel ER_DRAWH RIZRULER No records match this request.E+ ) = 1